How to Record a Macro to Automate Tasks in Excel 2010 ... You can use macros in Excel 2010 to save time by automating tasks that you perform frequently. A macro is a series of commands grouped together that you can ...